select a.dftpic as dftpic1, b.Latitude as b_Latitude, b.Longitude as b_Longitude,* from [houses] a, [base_property] b, [base_cityDistrict] c where audit=1 and a.pid = b.pid and b.did = c.id and a.del=0 and a.locker=0 and b.del=0 and b.locker=0 and a.isShowEn=0 and (b.cnpropertyname like '%Old house in Ruijin Er Road%' or b.enpropertyname like '%Old house in Ruijin Er Road%') order by updateTime Desc, a.dftpic desc
around IAPM,close to L1 L10 L12,5min walking distance to South shanxi rd metro station and Middle Huaihai rd metro station ,north european ins style decoration ...